Permission requirements
When you use the DataServer to create a schema image in a schema holder, it accesses the associated MS SQL Server database. This section describes the data source permissions required when you create, update, or connect to a schema image.
Permissions for Creating or Updating a Schema Holder
You must have select privileges on syscolumns, sysindexes, sysobjects and sysusers tables in your MS SQL Server database to create or update a schema image. This is because the DataServer utilities must access these tables, but they cannot do so without select privileges. However, this is the only time that you need this level of privilege when using the DataServer.
Permissions for connecting a schema holder
When you connect to a schema holder, you can optionally also connect to your MS SQL Server database. To connect to the data source, you must provide a valid login name and password combination. Use the User ID (-U) parameter to provide the user ID and the Password (-P) parameter to provide the password. Figure 5–1 shows an example of this User ID and Password dialog box.
Application-specific permissions
In addition to the MS SQL Server database permissions required by the DataServer, the required permissions for users depend on the applications that they are using. For example, a user who is running an OpenEdge application that queries but does not update the employee table in the data source must connect to the data source with a login name and password combination that provides at least select privileges for the employee table. For users who will manipulate data at runtime, the appropriate select, insert, update, and delete permissions must be granted as administered by the foreign (target) data source.
In summary, the login name (or user ID) and password combination required to run a particular application depends on the following: